Toufong Vang
Toufong Vang
Reactions
-
Re: Pls Help! Automating Rollover of dates Based on change of a status
@Mark_Gibbons_1 We have a few collection of sheets that require a similar setup. Below is how we achieve it. Your current deadline is a dynamic date. It depends on a previously, known deadline. Addit…1 · -
Re: Finding the most recent entry
=MAX(COLLECT(Date:Date, Number:Number, Number@row)) Hi, @Bradley CO , your ranges are transposed. Here's documentation on the COLLECT() function.1 · -
Re: Help with SUMIFS formula with two columns as criteria.
Hi, @Coen . Check if the values in [Applied to FY]:[Applied to FY] are strings/text or numbers. Use =COUNTIF([Applied to FY]:[Applied to FY], "2024"). If it returns "0" then the v…1 · -
Re: Can a barcode scanner be used in conjunction with Smartsheet Asset Management
We do not have any specialized scanners. The two models we use are the corded Zebra DS2208 and the cordless Zebra DS3678-SR. There's no programming involved other than adding a TAB key or an ENTER ke…1 · -
Re: Formula for checkbox when date is previous month (and considers previous year in Dec)
Hi, @Ami Veltrie , this will work for all dates: =IFERROR(IF(((YEAR(TODAY()) - YEAR([Payment Date]@row)) * 12) + MONTH(TODAY()) - MONTH([Payment Date]@row) = 1, 1, ""), "") The &q…1 ·
